﻿SET QUOTED_IDENTIFIER ON;
GO
SET ANSI_NULLS ON;
GO

-- Insert Products
-- Fruits
INSERT INTO ProductSet(Name, ShelfLife, Fruit, Vegetable, Other)
	VALUES('Pommes', 60, 1, 0, 0)
INSERT INTO ProductSet(Name, ShelfLife, Fruit, Vegetable, Other)
	VALUES('Poires', 30, 1, 0, 0)
INSERT INTO ProductSet(Name, ShelfLife, Fruit, Vegetable, Other)
	VALUES('Fraises', 7, 1, 0, 0)

-- Vegetables
INSERT INTO ProductSet(Name, ShelfLife, Fruit, Vegetable, Other)
	VALUES('Pommes de terre', 90, 0, 1, 0)
INSERT INTO ProductSet(Name, ShelfLife, Fruit, Vegetable, Other)
	VALUES('Carottes', 30, 0, 1, 0)

-- Other
INSERT INTO ProductSet(Name, ShelfLife, Fruit, Vegetable, Other)
	VALUES('Champignons de paris', 12, 0, 0, 1)